SERVER\SQLEXPRESS

SELECT     VoucherDate, EntryDateTime, ModifyDateTime, ReportDate, TestDate
FROM         Voucher

01-Jul-24 12:00:00 AM	01-Jul-24 3:09:39 PM	01-Jul-24 3:09:39 PM	01-Jul-24 2:18:00 PM	NULL


UPDATE Voucher
SET TestDate = DATEADD(MINUTE, -30, ReportDate)
WHERE ReportDate IS NOT NULL;


-----------KBS QUERY

SELECT     vw_PartiesInfo_1.PartyID, vw_PartiesInfo_1.PartyCode, vw_PartiesInfo_1.AccountNo, vw_PartiesInfo_1.PartyTitle, SUM(ISNULL(Opening.OpeningBalance, 0)) AS OpeningBalance, 
                      SUM(ISNULL(VouchersDebit.VouchersDebit, 0)) AS Debit, SUM(ISNULL(VoucherCredit.VoucherCredit, 0)) AS Credit, SUM(ISNULL(Sales.QTY, 0)) AS TotalSales, 0 AS SalesRecovery
FROM         (SELECT     AccountNo, SUM(ISNULL(OpeningBal, 0)) AS OpeningBalance
                       FROM          (SELECT     AccountNo, SUM(ISNULL(OpeningBal, 0)) AS OpeningBal
                                               FROM          SessionBalances
                                               WHERE      (SessionID = 1)
                                               GROUP BY AccountNo
                                               UNION ALL
                                               SELECT     AccountNo, SUM(Debit) - SUM(Credit) AS Balance
                                               FROM         vw_VouchersDetail
                                               WHERE     (0 = 0) AND (SessionID = 1) AND (VoucherDate < '01-Feb-2026')
                                               GROUP BY AccountNo) AS TempTable
                       GROUP BY AccountNo) AS Opening RIGHT OUTER JOIN
                          (SELECT     VoucherDetails.AccountNo, SUM(VoucherDetails.Amount) AS VouchersDebit
                            FROM          VoucherDetails INNER JOIN
                                                   Voucher ON VoucherDetails.VoucherID = Voucher.VoucherID
                            WHERE      (0 = 0) AND (VoucherDetails.DrOrCr = N'Dr') AND (Voucher.SessionID = 1) AND (Voucher.VoucherDate BETWEEN '01-Feb-2026' AND '18-Feb-2026')
                            GROUP BY VoucherDetails.AccountNo) AS VouchersDebit RIGHT OUTER JOIN
                          (SELECT     VoucherDetails_1.AccountNo, SUM(VoucherDetails_1.Amount) AS VoucherCredit
                            FROM          VoucherDetails AS VoucherDetails_1 INNER JOIN
                                                   Voucher AS Voucher_1 ON VoucherDetails_1.VoucherID = Voucher_1.VoucherID
                            WHERE      (0 = 0) AND (VoucherDetails_1.DrOrCr = N'Cr') AND (Voucher_1.SessionID = 1) AND (Voucher_1.VoucherDate BETWEEN '01-Feb-2026' AND '18-Feb-2026')
                            GROUP BY VoucherDetails_1.AccountNo) AS VoucherCredit RIGHT OUTER JOIN
                          (SELECT     vw_PartiesInfo.AccountNo, SUM(data_SalesDetail.Weight) AS QTY
                            FROM          data_SalesDetail INNER JOIN
                                                   data_SalesInfo ON data_SalesDetail.SalesID = data_SalesInfo.SalesID LEFT OUTER JOIN
                                                   vw_PartiesInfo ON data_SalesInfo.PartyID = vw_PartiesInfo.PartyID
                            WHERE      (data_SalesInfo.Type = 'SALES') AND (data_SalesInfo.SessionID = 1) AND (vw_PartiesInfo.SectorID = 13) AND (data_SalesDetail.ProductID IN
                                                       (SELECT     ProductID
                                                         FROM          vw_ProductsInfo
                                                         WHERE      (GroupID = 2))) AND (data_SalesInfo.SalesDate BETWEEN '01-Feb-2026' AND '18-Feb-2026')
                            GROUP BY vw_PartiesInfo.AccountNo) AS Sales RIGHT OUTER JOIN
                      vw_PartiesInfo AS vw_PartiesInfo_1 ON Sales.AccountNo = vw_PartiesInfo_1.AccountNo ON VoucherCredit.AccountNo = vw_PartiesInfo_1.AccountNo ON 
                      VouchersDebit.AccountNo = vw_PartiesInfo_1.AccountNo ON Opening.AccountNo = vw_PartiesInfo_1.AccountNo
WHERE     (0 = 0) AND (vw_PartiesInfo_1.Discontinue = 0) AND (vw_PartiesInfo_1.SectorID = 13) AND (vw_PartiesInfo_1.PartyID <> 1)
GROUP BY vw_PartiesInfo_1.AreaID, vw_PartiesInfo_1.AreaTitle, vw_PartiesInfo_1.SectorID, vw_PartiesInfo_1.SectorTitle, vw_PartiesInfo_1.PartyID, vw_PartiesInfo_1.PartyCode, vw_PartiesInfo_1.PartyTitle, 
                      vw_PartiesInfo_1.AccountNo
HAVING      (SUM(ISNULL(Opening.OpeningBalance, 0)) + SUM(ISNULL(VouchersDebit.VouchersDebit, 0)) - SUM(ISNULL(VoucherCredit.VoucherCredit, 0)) <> 0)
ORDER BY vw_PartiesInfo_1.PartyTitle